MySQL, MySQLi, PDO?

October 5, 2009 · 28 views · 0 comments

MySQL, MySQLi, PDO?
taken by : Dedric Mauriac
on Leonis (64, 8, 24)
blog HUD!
Busy
Online

About

My head has been wrapped around optimizing my queries today for my inventory server back-end. I started with the MySQL extension, because I'm using MySQL. However, I wanted to create a wrapper that would handle common code. I got so far as to load scripts from the file system, but the problem came with parameters. I found that MySQLi was good for supporting the question mark "?" tag as a parameter so long as I specified the datatypes ahead of type for proper formatting. I believe I hit the jack pot when I discovered that PDO actually supported named parameters. I've condensed my code down to a third of it's original space and made things a bit more manageable. I need some sleep. From Dedric Mauriac via bloghud.com